COALESCE ( expression [ ,…n ] ) Coalesce is Equivalent with CASE WHEN (expression1 IS NOT NULL) THEN expression1 WHEN (expression2 IS NOT NULL) THEN expression2 … ELSE expressionN END END My little experiment with coalesce DECLARE @i VARCHAR(20) DECLARE @exp2 SET @exp2 = NULL SET @i = null SELECT COALESCE (@i + ‘ more;’, … Continue reading Coalesce another IsNull method